﻿namespace Abs.Core.DAL
{
    internal static class StoredProcedures
    {
        internal const string GetIdentity = @"dbo.GetIdentity";

        //USER
        internal const string CreateUser = @"dbo.CreateUser";
        internal const string DeleteUser = @"dbo.DeleteUser";
        internal const string EditPassword = @"dbo.EditPassword";
        internal const string EditUser = @"dbo.EditUser";
        internal const string EditUserName = @"dbo.EditUserName";
        internal const string EditUserRoleId = @"dbo.EditUserRoleId";
        internal const string GetUser = @"dbo.GetUser";
        internal const string GetUsers = @"dbo.GetUsers";
        internal const string LogOn = @"dbo.LogOn";

        //ROOM
        internal const string CreateRoom = @"dbo.CreateRoom";
        internal const string DeleteRoom = @"dbo.DeleteRoom";
        internal const string EditRoom = @"dbo.EditRoom";
        internal const string GetRoom = @"dbo.GetRoom";
        internal const string GetRooms = @"dbo.GetRooms";

        //ROOM SCHEDULE
        internal const string CreateRoomSchedule = @"dbo.CreateRoomSchedule";
        internal const string DeleteRoomSchedule = @"dbo.DeleteRoomSchedule";
        internal const string DeleteRoomScheduleByRoomId = @"dbo.DeleteRoomScheduleByRoomId";
        internal const string EditRoomSchedule = @"dbo.EditRoomSchedule";
        internal const string GetRoomSchedule = @"dbo.GetRoomSchedule";
        internal const string GetRoomSchedules = @"dbo.GetRoomSchedules";
        internal const string GetRoomsOnDay = @"dbo.GetRoomsOnDay";
        
        //APPOINTMENT
        internal const string CreateAppointment = @"dbo.CreateAppointment";
        internal const string DeleteAppointment = @"dbo.DeleteAppointment";
        internal const string EditAppointment = @"dbo.EditAppointment";
        internal const string GetAppointment = @"dbo.GetAppointment";
        internal const string GetAppointments = @"dbo.GetAppointments";
    }//end of internal static class StoredProcedures
}//end of namespace